Scheduling Dataset by time using Once
- By using this document user will learn to Schedule Dataset using once.
Schedule Dataset using Once: This video contains how to Schedule Dataset using Once in OPNBI.
Scheduling Dataset in the OPNBI based on Once:-
- In order to schedule the dataset once during an hour, day, week, month or year following steps should be followed:-
Log in to OPNBI using your respective credentials.
Go to Hamburger Menu
> MasterData > Dataset.
User will see the window as below:
We will be using Employees.ds in the dataset section for the purpose of understanding.
Download schedule.zip from this given schedule.zip.
Follow this link & upload the downloaded zip into OPNBI as shown.
Click on schedule icon
to schedule dataset & user will see the following dialog box:-
Go to the schedule tab. By default, Schedule Type will be Time else select Time in schedule type time from the drop down menu.
Choose Once in the Frequency radio button..
Click on icon as shown in the image above & select the time as per requirement from the drop-down.
User can also select time by clicking on calender icon as shown in the image below:-
You can also specify how many times the dataset should re-execute in case of failure and the interval from the drop down menu shown in the figure. For instance, in our case the dataset will be executed twice in case of failure within duration of 5 minutes.
Click on Share in case you want to share the dataset with other users or user roles.
Here the Visibility is kept Internal for this example.
If you want to schedule dataset request to be approved before sending to other users, then check Approval Required.
info
- Approval Required option is not available in Schedule Dataset.
Send Reminder specifies how many reminder should be sent.
After days specifies after how many days should the Reminder be sent again.
Approved by specifies the user name, which is Admin in our case.
In order to specify the output, go to the output tab as follows:-
Enter the name by which you want to schedule the dataset in the Name text area, also provide optional suffix if required.
Select the format cds from the dropdown menu.
You can also specify event on success/failure of the dataset which will trigger an event and execute all the waiting for event datasets. We will discuss about this in detail in the event scheduling.
You can also specify the delivery path on your computer where the datset will be downloaded as follows.
The user can also send the dataset as email to the other users using following steps:-
Select the users and the roles from the drop-down menu.
Enter the email address to which you want to send the report via email.
Select a template from the dropdown, we have selected the Default template for our example.
Click on Schedule icon
in order to schedule the dataset.In case of any further help, the user can click on the
icon to access the OPNBIHUB help documents.If the user is not satisfied and wants to cancel the schedule request, he can do this by clicking on the cancel button next to upload or by clicking on
button next to the icon.The dataset is scheduled and cds file is created. The user can see the schedule request in the Request section of the OPNBIHUB application. This section displays all the reports that have completed, running, waiting for event or scheduled. In case of dataset scheduling failure, an error is also displayed on this page.
After scheduled the dataset using Once, user will see the scheduled dataset in Dataset section.
It will saved in dataset section as the [Dataset Name.cds]. For this example; it will be saved as Employees.cds in Dataset section.
info
The dataset is scheduled and .cds file is created. The user can see the schedule request in the Request section of the OPNBIHUB application. This section displays all the dataset scheduling that have completed, running, waiting for event or scheduled. In case of dataset scheduling failure, an error is also displayed on this page.
Click here to know how to use Request Section.